Dashboard
VIEWING ROOM ACTIVITIES
Select Room
prepare("select * from rooms") ; $grm->execute() ; while($row = $grm->fetch(pdo::FETCH_ASSOC) ) { $roomno = $row['Room_no'] ; $roomcat = $row['Room_category'] ; $vw = $roomcat.'-'.$roomno ; ?>
Room Activity Record" ; ?>
SN
BOOKING-ID
CUSTOMER
ROOM NO
CHECK-IN
CHECK-OUT
GUEST NO
AMOUNT
prepare("select * from booking_table where Room_no = '$room'") ; $getrec->execute() ; //get sum $gsum = $DBcon->prepare("select sum(T_cost) as gcost from booking_table where Room_no = '$room' ") ; $gsum->execute() ; $gsrow = $gsum->fetch(pdo::FETCH_ASSOC) ; $tsum = $gsrow['gcost'] ; $count = 0 ; while($row = $getrec->fetch(pdo::FETCH_ASSOC)) { $count++ ; ?>
Grand Total
